Relational database Guides d'étude, Notes de cours & Résumés

Which result set requires a JOIN?
a.)
Showing all track names with genre names
b.)
Showing all track names with genre IDs
c.)
Showing all genre names with genre IDs
d.)
Showing all track names with both genre ID and track ID Which result set requires a JOIN?
a.)
Showing all invoice totals with both customer ID and invoice ID
b.)
Showing all customer names with customer IDs
c.)
Showing all invoice totals with customer last names
d.)
Showing all inv...

Schema The definition of how data in a database will be organized. - Create - Read - Update - Delete The basis of interacting with databases can be defined using the CRUD acronym. What does CRUD stand for? Brainpower 0:02 / 0:15 DATE: YYYY-MM-DD DATETIME: YYYY-MM-DD HH:MM:SS What is the DATE datatype syntax? What is the DATETIME datatype syntax? It will have 3 numbers before the decimal and 2 after. What does DECIMAL(3,2) indicate? Stored Procedures ...

Sophia Intro to Relational Database Milestone Final

WGU CS1011 Sophia Introduction to Relational Databases Milestone 2 Retake Questions and Answers Score 20/25. 20/25  that's 80% RETAKE  20 questions were answered correctly. 4 questions were answered incorrectly. 1 question was skipped. These were marked incorrect. In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. Which of the fol...

WGU CS1011 Sophia Introduction to Relational Databases Milestone 1 Retake Questions and Answers (Score 33/36) Latest. 33/36  that's 92% RETAKE  33 questions were answered correctly. 3 questions were answered incorrectly. In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. Identify the correctly constructed ALTER TABLE statement to ...

True & False The objective of SOL performance tuning on the client side is to generate an SOL query that returns the correct answer in the least amount of time, using the maximum amount of resources on the server side All database transactions must display at least the properties of Atomicity, consistency, convenience, and isolation Database recovery techniques are based on the isolation transaction property which indicate that the data used during execution of a transaction cannot...

1.2 SINGLE TABLE CONSTRUCTION The following CREATE TABLE statement creates a table called 'company' that consists of the company_id as the primary key, the company_name, and the address. CREATE TABLE company( company_id INT PRIMARY KEY company_name VARCHAR (100), address VARCHAR (100) ); Identify the line of code that would generate an error in this CREATE TABLE statement.
a.)
2
b.)
4
c.)
1
d.)
3
The following CREATE TABLE statement creates a table called ...

Identify the SQL command that uses an aggregate function that could be used to find the lowest total in the invoice table.
a.)
SELECT lowest(total) FROM invoice;
b.)
SELECT total(min) FROM invoice;
c.)
SELECT min total FROM invoice;
d.)
SELECT min(total) FROM invoice; Identify the SQL command that uses an aggregate function that could be used to find the average total in the invoice table.
a.)
SELECT avg(total) from invoice;
b.)
SELECT average total FROM in...

Introduction to Relational Databases Milestone 1 Retake Questions and Answers (Score 33/36) Latest. 33/36  that's 92% RETAKE  33 questions were answered correctly. 3 questions were answered incorrectly. In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. Identify the correctly constructed ALTER TABLE statement to add a UNIQUE const...

Which of the following statement(s) would successfully delete the invoice_id 353 from the invoice table?
a.)
DELETE FROM invoice_line WHERE invoice_id = 353;
DELETE FROM invoice WHERE invoice_id = 353;
b.)
DELETE FROM invoice WHERE invoice_id = 353;
c.)
DELETE FROM invoice WHERE invoice_id = 353;
DELETE FROM invoice_line WHERE invoice_id = 353;
d.)
DELETE FROM invoice_line WHERE invoice_id = 353 Which of the following statement(s) would successfully delete the inv...